SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS OFF
GO
CREATE PROCEDURE [dbo].[paCertificaObtenerDestinatariosSP] 
-- < Registro de Actualizaciones >
-- 25-10-2006 

	@IdSubProyecto 	INT 

AS
SET NOCOUNT ON
SELECT D.IdDestinatario AS ID, Descripcion 
	FROM tb_Destinatarios D
	INNER JOIN tb_RelDestinatariosSP DSP ON DSP.IdDestinatario=D.IdDestinatario AND DSP.IdSubProyecto=@IdSubProyecto
	ORDER BY Descripcion
GO
GRANT EXECUTE ON  [dbo].[paCertificaObtenerDestinatariosSP] TO [Certificaciones]
GRANT EXECUTE ON  [dbo].[paCertificaObtenerDestinatariosSP] TO [CertificacionesAdministracion]
GRANT EXECUTE ON  [dbo].[paCertificaObtenerDestinatariosSP] TO [SoloVer]
GO
